﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

/* dbo.ProgramType (BEGIN) */

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Preventitive Care/Wellness', 'Preventitive Care/Wellness', 'AG', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('24 Hour Care', '24 Hour Care', 'AH', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Medicare Risk', 'Medicare Risk', 'AJ', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Mental Health', 'Mental Health', 'AK', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Dental Capitation', 'Dental Capitation', 'DCP', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Dental', 'Dental', 'DEN', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Exclusive Provider Organization', 'Exclusive Provider Organization', 'EPO', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Facility', 'Facility', 'FAC', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Hearing', 'Hearing', 'HE', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Health', 'Health', 'HLT', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Health Maintenance Organization', 'Health Maintenance Organization', 'HMO', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Long-Term Care', 'Long-Term Care', 'LTC', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Long-Term Disability', 'Long-Term Disability', 'LTD', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Major Medical', 'Major Medical', 'MM', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Mail Order Drug', 'Mail Order Drug', 'MOD', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Prescription Drug', 'Prescription Drug', 'PDG', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Point of Service', 'Point of Service', 'POS', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Preferred Provider Organization', 'Preferred Provider Organization', 'PPO', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Practitioners', 'Practitioners', 'PRA', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Short-Term Disability', 'Short-Term Disability', 'STD', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Utilization Review', 'Utilization Review', 'UR', 1)

INSERT INTO ProgramType (Name, Description, Code, Enabled)  VALUES ('Vision', 'Vision', 'VIS', 1)

/* dbo.ProgramType ( END ) */

